{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["New","UpdateMetadata","Deprecate","Undeprecate","Remove","AddValue","ReplaceValue","RemoveValue","DeprecateValue","UndeprecateValue","ReplaceType","Internal Info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"New","index":0,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Proposed Full Schema Path","Data Type","Description","Prompt","Report Prompt","SuppressUIField","SuppressUI Notes","Possible Values","OPPSAFlag","Expere NPI","C1 NPI","UCD","UCDMapping","TXN to MISMO Mapping","Additional Notes","Approved Full Schema Path","Schema Data Type","EngineOnly"]
["New","Carrie.Allen",12345,"HE-APP","/Txn/Borrowers/Borrower/EyeColorType","Enumeration","Describes the eye color of the borrower.","Eye Color",null,"N",null,"Brown; Hazel; Blue; Green","N","N","N","N",null,null,null,"/Txn/Borrowers/Borrower/EyeColorType","EyeColorTypeEnum","N"]
["New","Carrie.Allen",null,null,"/Txn/Deposit/AccountAgreementCustomerInformationType","Enumeration","Specifies what level of customer information should be included in the account agreements or safe deposit box leases.",null,null,"Y",null,"1 = All Party Information; 2 = Primary Party Information Only; 3 = Basic Information Only","N","N","N","N",null,null,null,"/Txn/Deposit/AccountAgreementCustomerInformationType","TxnDepositAccountAgreementCustomerInformationTypeEnum","N"]
["New","Carrie.Allen",null,null,"/Txn/Borrowers/Borrower/AlternateAddressCity","String","Specifies the capacity of the representative entity (for example General Partner).",null,null,"Y",null,null,"N","N","N","Y","MESSAGE/DOCUMENT_SETS/DOCUMENT_SET/DOCUMENTS/DOCUMENT/DEAL_SETS/DEAL_SET/DEALS/DEAL/PARTIES/PARTY/ADDRESSES/ADDRESS/CityName","MESSAGE/DOCUMENT_SETS/DOCUMENT_SET/DOCUMENTS/DOCUMENT/DEAL_SETS/DEAL_SET/DEALS/DEAL/PARTIES/PARTY/ADDRESSES/ADDRESS/CityName",null,"/Txn/Borrowers/Borrower/AlternateAddressCity","TxnString","N"]
["New","Carrie.Allen",null,null,"/Txn/AddedNotes","Collection","Collects information about one or more added notes.",null,null,"N",null,null,"N","N","N","N",null,null,null,"/Txn/AddedNotes","AddedNotes","N"]
["New","Carrie.Allen",null,null,"/Txn/AddedNotes/AddedNote","Container","Contains information about one added note.","PRINT 'Added Note - ' ./ID",null,"N",null,null,"N","N","N","N",null,null,null,"/Txn/AddedNotes/AddedNote","AddedNote","N"]
["New","Carrie.Allen",null,null,"/Txn/AddedNotes/AddedNote/ID","String","The unique identifier for the note.","Added Note ID",null,"N",null,null,"N","N","N","N",null,null,null,"/Txn/AddedNotes/AddedNote/ID","TxnString","N"]

{"sheet":"UpdateMetadata","index":1,"n_rows":5,"n_cols":20,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Description","Prompt","Report Prompt","SuppressUIField","SuppressUI Notes","OPPSAFlag","Expere NPI","C1 NPI","UCD","UCDMapping","TXN to MISMO Mapping","Additional Notes","Deprecation Notes","Removal Date","EngineOnly"]
["UpdateMetadata","Carrie.Allen",null,null,"/Txn/CollateralItems/Collateral/ProjectCity","The city portion of the street address of the project. (This is specific to the condominium or planned unit development (PUD)).",null,null,null,null,null,null,null,null,null,null,"The description is being updated. No other changes are being made to the path.",null,null,"N"]
["UpdateMetadata","Carrie.Allen",null,null,"/Txn/CollateralItems/Collateral/Products/Product",null,"PRINT 'Product - ' IF ./ProductName != '' THEN PRINT ./ProductName ELSE PRINT ./ProductDesc ENDIF",null,null,null,null,null,null,null,null,null,"The prompt is being updated. No other changes are being made to the path.",null,null,"N"]
["UpdateMetadata","Carrie.Allen",null,null,"/Txn/Notes/Note/MasterNoteInd",null,null,null,"N","Per customer request, this field is being unsuppressed as it is causing issues in their system.",null,null,null,null,null,null,null,null,null,"N"]
["UpdateMetadata","Carrie.Allen",null,null,"/Txn/SBAExportWorkingCapitalProgramLoanType",null,null,null,null,null,null,null,null,null,null,null,"Removing the removal date",null,"[blank]","N"]

{"sheet":"Deprecate","index":2,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Deprecation Notes","Removal Date","Additional Notes"]
["Deprecate","Carrie.Allen",null,null,"/Txn/Borrowers/Borrower/IllinoisLandTrustInd","Replaced by: /Txn/Borrowers/Borrower/LandTrustInd"]
["Deprecate","Carrie.Allen",null,null,"/Txn/Borrowers/Borrower/Signers/Signer/PartyType","A signer will always be an individual. Party Type is not valid at this location.","02/26/2022"]
["Deprecate","Carrie.Allen",null,null,"/Txn/FormMotorVehicleNoticeNewJerseyOrgCorporateCodeIdentifier","The form this path is used on is being discontinued since New Jersey has combined it with two others into a single form.  There is no replacement path."]

{"sheet":"Undeprecate","index":3,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Description","Prompt","Report Prompt","SuppressUIField","SuppressUI Notes","Additional Notes"]
["Undeprecate","Carrie.Allen",null,null,"/Txn/CollateralItems/Collateral/AircraftDesc",null,null,null,null,null,"This path is being undeprecated. No other metadata requires an update so it has not been populated."]
["Undeprecate","Carrie.Allen",null,null,"/Txn/FormMotorVehicleNoticeNewJerseyOrgCorporateCodeIdentifier","The corporate code identifier.","Corporate Code Identifier",null,"N",null,"This path is being undeprecated. The description was modified, and the suppresion changed now requiring a prompt to be passed."]

{"sheet":"Remove","index":4,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path"]
["Remove","Carrie.Allen",null,null,"/Txn/ServicingDefaultBreachInd"]

{"sheet":"AddValue","index":5,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Possible Value","Additional Notes"]
["AddValue","Carrie.Allen",null,null,"/Txn/ApplicationDecisionType","4 = New Value","This path is having 2 possible values added: 4 = New Value and 5 = Another Value"]
["AddValue","Carrie.Allen",null,null,"/Txn/ApplicationDecisionType","5 = Another Value"]
["AddValue","Carrie.Allen",null,null,"/Txn/CollateralItems/Collateral/FormBoatTitleApplicationIowaFuelType","4 = Electric","This path is having a possible value added under this tab, and a possible value revised under the \"ReplaceValue\" tab."]

{"sheet":"ReplaceValue","index":6,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Current Possible Value","New Possible Value","Additional Notes"]
["ReplaceValue","Carrie.Allen",null,null,"/Txn/CollateralItems/Collateral/FormBoatTitleApplicationIowaFuelType","1 = Gas","1 = Gasoline","This path is having a possible value added under this tab, and a possible value revised under the \"ReplaceValue\" tab."]

{"sheet":"RemoveValue","index":7,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Possible Value","Additional Notes"]
["RemoveValue","Carrie.Allen",null,null,"/Txn/ApplicationDecisionType","3 = Counteroffer/Not Accepted","Removing possible value 3"]

{"sheet":"DeprecateValue","index":8,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Possible Value","Deprecation Notes","Additional Notes"]
["DeprecateValue","Carrie.Allen",null,null,"/Txn/Notes/Note/LossMitigations/LossMitigation/Programs/Program/FlexDenialReasons/FlexDenialReason/Type","12 = Eligible Hardship","Replaced by 19 = No Eligible Hardship"]

{"sheet":"UndeprecateValue","index":9,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Possible Value","Additional Notes"]
["UndeprecateValue","Carrie.Allen",null,null,"/Txn/Notes/Note/RateInfoItems/RateInfoItem/LIBORIndexPeriodType","2 = 2 Months"]

{"sheet":"ReplaceType","index":10,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Change Type","Requester","PBI Number(s)","Document ID(s)","Full Schema Path","Data Type","Possible Values","Additional Notes","Schema Data Type"]
["ReplaceType","Carrie.Allen",null,null,"/Txn/BeaconScoreNumber","String",null,"Updating data type from a decimal to a string.","TxnString"]
["ReplaceType","Carrie.Allen",null,null,"/Txn/Assets/Asset/AccountEntityState","Enumeration","AB = Alberta; AK = Alaska; AL = Alabama; AR = Arkansas; AZ = Arizona; BC = British Columbia; CA = California; CO = Colorado; CT = Connecticut; DC = District of Columbia; DE = Delaware; FL = Florida; GA = Georgia; HI = Hawaii; IA = Iowa; ID = Idaho; IL = Illinois; IN = Indiana; KS = Kansas; KY = Kentucky; LA = Louisiana; MA = Massachusetts; MB = Manitoba; MD = Maryland; ME = Maine; MI = Michigan; MN = Minnesota; MO = Missouri; MS = Mississippi; MT = Montana; NB = New Brunswick; NC = North Carolina; ND = North Dakota; NE = Nebraska; NH = New Hampshire; NJ = New Jersey; NL = Newfoundland and Labrador; NM = New Mexico; NS = Nova Scotia; NT = Northwest Territories; NU = Nunavut; NV = Nevada; NY = New York; OH = Ohio; OK = Oklahoma; ON = Ontario; OR = Oregon; PA = Pennsylvania; PE = Prince Edward Island; PR = Puerto Rico; QC = Quebec; RI = Rhode Island; SC = South Carolina; SD = South Dakota; SK = Saskatchewan; TN = Tennessee; TX = Texas; UT = Utah; VA = Virginia; VT = Vermont; WA = Washington; WI = Wisconsin; WV = West Virginia; WY = Wyoming; YT = Yukon","Changing possible value list to include puerto rico.","StateProvincePuertoRicoEnum"]

{"sheet":"Internal Info","index":11,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Drop down list definitions:"]
["Boolean","TXNDataType"]
["Y","Boolean"]
["N","Collection"]
[null,"Container"]
[null,"Date"]
[null,"Decimal"]
[null,"Enumeration"]
[null,"Integer"]
[null,"Money"]
[null,"String"]